Excel 2013 - Working with Cells, Search Tools and Sorting Data |
| |
The "Excel 2013 - Working with Cells, Search Tools and Sorting Data" lesson covers the following topics:- Cell Selection Techniques
- Moving and Copying Data
- Adding and Removing Cells
- Searching and Sorting Data
|
|
| |
Cell Selection Techniques |
|
| |
Upon successful completion you will be able to:
1. Select a Cell; 2. Select Ranges of Cells; 3. Select Columns; 4. Select Rows; 5. De-select Cells; 6. Select Data Ranges; 7. Select the Entire Worksheet.
|
|
| |
Upon successful completion you will be able to:
1. Understand Cut and Copy; 2. Move Data in Worksheets; 3. Move Data Between Worksheets; 4. Move Data Between Workbooks; 5. Use the Paste Options Smart Tag; 6. Copy Data in Worksheets; 7. Copy Data Between Worksheets; 8. Copy Data Between Workbooks; 9. Use the Office Clipboard.
|
|
| |
Adding and Removing Cells |
|
| |
Upon successful completion you will be able to:
1. Insert Columns and Rows; 2. Delete Columns and Rows; 3. Insert Cells; 4. Delete Cells; 5. Adjust Column Widths; 6. Change Row Heights; 7. Use Undo; 8. Use Redo; 9. Delete Cell Content. |
|
| |
Searching and Sorting Data |
|
| |
Upon successful completion you will be able to;
1. Use Find and Replace; 2. Search for Words; 3. Identify Search Options; 4. Use Find Next; 5. Replace Single Occurrences; 6. Use Replace All; 7. Sort Data in Columns.
|
|
| This course can be purchased either individaully or as part of a package. |
| Single Training Course - Excel 2013 - Working with Cells, Search Tools and Sorting Data : |  |
| Program Training Courses - Microsoft Excel 2013 : |  |
| Office Suite Training Courses - Microsoft Office 2013 : |  |
|
| © 2017 Online Training Masters |